using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
    public partial class VDRBSUB
    {
        public DataRow Convert2DRBSUB(DataRow dwInput, string ITXDBVERSION, bool IsConvert = false)
        {
            DataSet SResult = new DataSet();
            SResult = QueryDRBSUB(dwInput, 0);
            DataRow dwReturn = null;
            if (SResult.Tables[0].Rows.Count > 0)
            {
                dwReturn = SResult.Tables[0].Rows[0];
            }
            else
            {
                dwReturn = SResult.Tables[0].NewRow();
            }
            switch (ITXDBVERSION)
            {
                case "YGR":
                    #region=========
         dwReturn["DRBSMANDANT"] = " ".PadRight(2 ); 
         dwReturn["DRBSNAME"] = " ".PadRight(8 ); 
         dwReturn["DRBSBEZ"] = " ".PadRight(50 ); 
         dwReturn["DRBSSUBSYS01"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS02"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS03"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS04"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS05"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS06"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS07"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS08"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS09"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS10"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS11"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS12"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS13"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS14"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS15"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS16"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS17"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS18"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS19"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS20"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS21"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS22"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS23"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS24"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS25"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS26"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS27"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS28"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS29"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS30"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS31"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS32"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS33"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS34"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS35"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS36"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS37"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS38"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS39"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS40"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS41"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS42"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS43"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS44"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS45"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS46"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS47"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS48"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS49"] = " ".PadRight(8 ); 
         dwReturn["DRBSSUBSYS50"] = " ".PadRight(8 ); 
         dwReturn["DRBSPAUSEVON"] = " ".PadRight(0 ); 
         dwReturn["DRBSPAUSEBIS"] = " ".PadRight(0 ); 
         dwReturn["DRBSINTERVALL"] = " ".PadRight(0 ); 
         dwReturn["DRBSNEUDAT"] = " ".PadRight(0 ); 
         dwReturn["DRBSNEUBEN"] = " ".PadRight(8 ); 
         dwReturn["DRBSAENDAT"] = " ".PadRight(0 ); 
         dwReturn["DRBSAENBEN"] = " ".PadRight(8 ); 
         dwReturn["DRBSAENDZL"] = " ".PadRight(0 ); 
         dwReturn["DRBSSTOP"] = " ".PadRight(1 ); 
         dwReturn["DRBSFILLER"] = " ".PadRight(27 ); 
                    #endregion
                    break;
                case "JLT":

                    break;
                default:

                    break;
            }
            if (IsConvert)
            {
                foreach (DataColumn cm in dwInput.Table.Columns)
                {
                    if (dwInput[cm.ColumnName].ToString() == "")
                        continue;
                    if (dwReturn.Table.Columns.Contains(cm.ColumnName))
                    {
                        dwReturn[cm.ColumnName] = dwInput[cm.ColumnName];
                    }
                }
            }
            return dwReturn;
        }
        public void MapDRBSUB(ref DataRow dwLocal, DataRow dwData)
        {
            BlindMap(ref dwLocal, dwData);
        }
        public void SaveDRBSUB(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            DataSet setResult = new DataSet();
            DataTable tbLocal = null;
            DataRow dwLocal = null;
            bool flgExist = false;
            setResult = QueryDRBSUB(dwData);
            if (setResult.Tables.Count > 0)
            {
                tbLocal = setResult.Tables[0];
                if (tbLocal.Rows.Count > 0)
                {
                    flgExist = true;
                    dwLocal = tbLocal.Rows[0];
                }
                else
                {
                    dwLocal = tbLocal.NewRow();
                }
            }
            MapDRBSUB(ref dwLocal, dwData);

            if (!flgExist)
            {

                InsertDRBSUB(dwLocal, ITXDBVERSION);
            }
            UpdateDRBSUB(dwLocal);
        }
        public void InsertDRBSUB(DataRow dwData, string ITXDBVERSION = "50.24")
        {
            OracleCommand or1;
            or1 = OracleDB.CreateCommand();
            switch (ITXDBVERSION)
            {
                case "YGR":
                    or1.CommandText = "INSERT INTO DRBSUB(VAKBMANDANT, VAKBKOLL, VAKBART, VAKBKUNDNR, VAKBFARBE, VAKBKDARTNR, VAKBKDARTBEZ, VAKBKDFARBNR, VAKBANDRUCK, VAKBMEGEW, VAKBMENGEH, VAKBGEWVON, VAKBGEWBIS, VAKBGEWCA, VAKBGEWFKT, VAKBGEWGRP, VAKBMEGFKT, VAKBMEGGRP, VAKBAENDZL, VAKBAENDBEN, VAKBAENDDAT, VAKBNEUBEN, VAKBNEUDAT, VAKBFILLER)"
                        + " VALUES (:VAKBMANDANT, :VAKBKOLL, :VAKBART, :VAKBKUNDNR, :VAKBFARBE, '                         ', '                         ', '                             ', ' ', '   ', '   ', 0, 0, ' ', '000000000000', ' ', '000000000000', ' ', 0, '        ', '000000', '        ', '      ', '                                          ')";
                    or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                //VAFMANDANT VAFKOLL VAFART VAFFARBE VAFBEZ VAFFFARBE

            }
            
            Connect2Proxy(or1);
        }
        public DataSet QueryDRBSUB(DataRow dwData, int option = 1)
        {
            DataSet Return;
            DataSet Result = new DataSet();
            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 0:
                    or1.CommandText = "SELECT * FROM DRBSUB WHERE  ROWNUM<2 ";
                    break;
              
                case 99:
                    or1.CommandText = "SELECT * FROM DRBSUB  WHERE ROWNUM<50";
                    break;
                default:
                    break;
            }
            Result = Connect2Proxy(or1);
            if (Result.Tables.Count > 0)
                Result.Tables[0].TableName = "DRBSUB";
            Return = Result;
            return Return;
        }
        public void DeleteDRBSUB(DataRow dwData, int option = 1)
        {

            OracleCommand or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    or1.CommandText = "DELETE FROM DRBSUB   WHERE  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                     or1.Parameters.Add("VAKBMANDANT", OracleType.NVarChar).Value = dwData["VAKBMANDANT"].ToString();
                    or1.Parameters.Add("VAKBKOLL", OracleType.NVarChar).Value = dwData["VAKBKOLL"].ToString();
                    or1.Parameters.Add("VAKBART", OracleType.NVarChar).Value = dwData["VAKBART"].ToString();
                    or1.Parameters.Add("VAKBFARBE", OracleType.NVarChar).Value = dwData["VAKBFARBE"].ToString();
                    or1.Parameters.Add("VAKBKUNDNR", OracleType.NVarChar).Value = dwData["VAKBKUNDNR"].ToString();
                    break;
                default:
                    break;
            }
            Connect2Proxy(or1);
        } 
      
        public void UpdateDRBSUB(DataRow dwData, string ITXDBVERSION = "50.24", int option = 1)
        {
            OracleCommand or1;
            DataSet Result = new DataSet();
            or1 = OracleDB.CreateCommand();
            switch (option)
            {
                case 1:
                    #region====Command==== 
                    or1.CommandText = "UPDATE DRBSUB SET "
                    +"DRBSMANDANT= :DRBSMANDANT,"
                    +"DRBSNAME= :DRBSNAME,"
                    +"DRBSBEZ= :DRBSBEZ,"
                    +"DRBSSUBSYS01= :DRBSSUBSYS01,"
                    +"DRBSSUBSYS02= :DRBSSUBSYS02,"
                    +"DRBSSUBSYS03= :DRBSSUBSYS03,"
                    +"DRBSSUBSYS04= :DRBSSUBSYS04,"
                    +"DRBSSUBSYS05= :DRBSSUBSYS05,"
                    +"DRBSSUBSYS06= :DRBSSUBSYS06,"
                    +"DRBSSUBSYS07= :DRBSSUBSYS07,"
                    +"DRBSSUBSYS08= :DRBSSUBSYS08,"
                    +"DRBSSUBSYS09= :DRBSSUBSYS09,"
                    +"DRBSSUBSYS10= :DRBSSUBSYS10,"
                    +"DRBSSUBSYS11= :DRBSSUBSYS11,"
                    +"DRBSSUBSYS12= :DRBSSUBSYS12,"
                    +"DRBSSUBSYS13= :DRBSSUBSYS13,"
                    +"DRBSSUBSYS14= :DRBSSUBSYS14,"
                    +"DRBSSUBSYS15= :DRBSSUBSYS15,"
                    +"DRBSSUBSYS16= :DRBSSUBSYS16,"
                    +"DRBSSUBSYS17= :DRBSSUBSYS17,"
                    +"DRBSSUBSYS18= :DRBSSUBSYS18,"
                    +"DRBSSUBSYS19= :DRBSSUBSYS19,"
                    +"DRBSSUBSYS20= :DRBSSUBSYS20,"
                    +"DRBSSUBSYS21= :DRBSSUBSYS21,"
                    +"DRBSSUBSYS22= :DRBSSUBSYS22,"
                    +"DRBSSUBSYS23= :DRBSSUBSYS23,"
                    +"DRBSSUBSYS24= :DRBSSUBSYS24,"
                    +"DRBSSUBSYS25= :DRBSSUBSYS25,"
                    +"DRBSSUBSYS26= :DRBSSUBSYS26,"
                    +"DRBSSUBSYS27= :DRBSSUBSYS27,"
                    +"DRBSSUBSYS28= :DRBSSUBSYS28,"
                    +"DRBSSUBSYS29= :DRBSSUBSYS29,"
                    +"DRBSSUBSYS30= :DRBSSUBSYS30,"
                    +"DRBSSUBSYS31= :DRBSSUBSYS31,"
                    +"DRBSSUBSYS32= :DRBSSUBSYS32,"
                    +"DRBSSUBSYS33= :DRBSSUBSYS33,"
                    +"DRBSSUBSYS34= :DRBSSUBSYS34,"
                    +"DRBSSUBSYS35= :DRBSSUBSYS35,"
                    +"DRBSSUBSYS36= :DRBSSUBSYS36,"
                    +"DRBSSUBSYS37= :DRBSSUBSYS37,"
                    +"DRBSSUBSYS38= :DRBSSUBSYS38,"
                    +"DRBSSUBSYS39= :DRBSSUBSYS39,"
                    +"DRBSSUBSYS40= :DRBSSUBSYS40,"
                    +"DRBSSUBSYS41= :DRBSSUBSYS41,"
                    +"DRBSSUBSYS42= :DRBSSUBSYS42,"
                    +"DRBSSUBSYS43= :DRBSSUBSYS43,"
                    +"DRBSSUBSYS44= :DRBSSUBSYS44,"
                    +"DRBSSUBSYS45= :DRBSSUBSYS45,"
                    +"DRBSSUBSYS46= :DRBSSUBSYS46,"
                    +"DRBSSUBSYS47= :DRBSSUBSYS47,"
                    +"DRBSSUBSYS48= :DRBSSUBSYS48,"
                    +"DRBSSUBSYS49= :DRBSSUBSYS49,"
                    +"DRBSSUBSYS50= :DRBSSUBSYS50,"
                    +"DRBSPAUSEVON= :DRBSPAUSEVON,"
                    +"DRBSPAUSEBIS= :DRBSPAUSEBIS,"
                    +"DRBSINTERVALL= :DRBSINTERVALL,"
                    +"DRBSNEUDAT= :DRBSNEUDAT,"
                    +"DRBSNEUBEN= :DRBSNEUBEN,"
                    +"DRBSAENDAT= :DRBSAENDAT,"
                    +"DRBSAENBEN= :DRBSAENBEN,"
                    +"DRBSAENDZL= :DRBSAENDZL,"
                    +"DRBSSTOP= :DRBSSTOP,"
                    +"DRBSFILLER= :DRBSFILLER,"
                        + " WHERE  "
                        + "  VAKBMANDANT=:VAKBMANDANT AND VAKBKOLL=:VAKBKOLL AND VAKBART =:VAKBART AND VAKBFARBE=:VAKBFARBE AND VAKBKUNDNR=:VAKBKUNDNR";
                    #endregion

                    #region====Parameters====
          or1.Parameters.Add("DRBSMANDANT", OracleType.NVarChar).Value = dwData["DRBSMANDANT"].ToString(); 
          or1.Parameters.Add("DRBSNAME", OracleType.NVarChar).Value = dwData["DRBSNAME"].ToString(); 
          or1.Parameters.Add("DRBSBEZ", OracleType.NVarChar).Value = dwData["DRBSBEZ"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS01", OracleType.NVarChar).Value = dwData["DRBSSUBSYS01"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS02", OracleType.NVarChar).Value = dwData["DRBSSUBSYS02"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS03", OracleType.NVarChar).Value = dwData["DRBSSUBSYS03"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS04", OracleType.NVarChar).Value = dwData["DRBSSUBSYS04"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS05", OracleType.NVarChar).Value = dwData["DRBSSUBSYS05"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS06", OracleType.NVarChar).Value = dwData["DRBSSUBSYS06"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS07", OracleType.NVarChar).Value = dwData["DRBSSUBSYS07"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS08", OracleType.NVarChar).Value = dwData["DRBSSUBSYS08"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS09", OracleType.NVarChar).Value = dwData["DRBSSUBSYS09"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS10", OracleType.NVarChar).Value = dwData["DRBSSUBSYS10"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS11", OracleType.NVarChar).Value = dwData["DRBSSUBSYS11"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS12", OracleType.NVarChar).Value = dwData["DRBSSUBSYS12"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS13", OracleType.NVarChar).Value = dwData["DRBSSUBSYS13"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS14", OracleType.NVarChar).Value = dwData["DRBSSUBSYS14"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS15", OracleType.NVarChar).Value = dwData["DRBSSUBSYS15"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS16", OracleType.NVarChar).Value = dwData["DRBSSUBSYS16"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS17", OracleType.NVarChar).Value = dwData["DRBSSUBSYS17"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS18", OracleType.NVarChar).Value = dwData["DRBSSUBSYS18"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS19", OracleType.NVarChar).Value = dwData["DRBSSUBSYS19"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS20", OracleType.NVarChar).Value = dwData["DRBSSUBSYS20"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS21", OracleType.NVarChar).Value = dwData["DRBSSUBSYS21"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS22", OracleType.NVarChar).Value = dwData["DRBSSUBSYS22"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS23", OracleType.NVarChar).Value = dwData["DRBSSUBSYS23"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS24", OracleType.NVarChar).Value = dwData["DRBSSUBSYS24"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS25", OracleType.NVarChar).Value = dwData["DRBSSUBSYS25"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS26", OracleType.NVarChar).Value = dwData["DRBSSUBSYS26"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS27", OracleType.NVarChar).Value = dwData["DRBSSUBSYS27"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS28", OracleType.NVarChar).Value = dwData["DRBSSUBSYS28"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS29", OracleType.NVarChar).Value = dwData["DRBSSUBSYS29"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS30", OracleType.NVarChar).Value = dwData["DRBSSUBSYS30"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS31", OracleType.NVarChar).Value = dwData["DRBSSUBSYS31"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS32", OracleType.NVarChar).Value = dwData["DRBSSUBSYS32"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS33", OracleType.NVarChar).Value = dwData["DRBSSUBSYS33"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS34", OracleType.NVarChar).Value = dwData["DRBSSUBSYS34"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS35", OracleType.NVarChar).Value = dwData["DRBSSUBSYS35"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS36", OracleType.NVarChar).Value = dwData["DRBSSUBSYS36"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS37", OracleType.NVarChar).Value = dwData["DRBSSUBSYS37"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS38", OracleType.NVarChar).Value = dwData["DRBSSUBSYS38"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS39", OracleType.NVarChar).Value = dwData["DRBSSUBSYS39"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS40", OracleType.NVarChar).Value = dwData["DRBSSUBSYS40"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS41", OracleType.NVarChar).Value = dwData["DRBSSUBSYS41"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS42", OracleType.NVarChar).Value = dwData["DRBSSUBSYS42"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS43", OracleType.NVarChar).Value = dwData["DRBSSUBSYS43"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS44", OracleType.NVarChar).Value = dwData["DRBSSUBSYS44"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS45", OracleType.NVarChar).Value = dwData["DRBSSUBSYS45"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS46", OracleType.NVarChar).Value = dwData["DRBSSUBSYS46"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS47", OracleType.NVarChar).Value = dwData["DRBSSUBSYS47"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS48", OracleType.NVarChar).Value = dwData["DRBSSUBSYS48"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS49", OracleType.NVarChar).Value = dwData["DRBSSUBSYS49"].ToString(); 
          or1.Parameters.Add("DRBSSUBSYS50", OracleType.NVarChar).Value = dwData["DRBSSUBSYS50"].ToString(); 
          or1.Parameters.Add("DRBSPAUSEVON", OracleType.NVarChar).Value = dwData["DRBSPAUSEVON"].ToString(); 
          or1.Parameters.Add("DRBSPAUSEBIS", OracleType.NVarChar).Value = dwData["DRBSPAUSEBIS"].ToString(); 
          or1.Parameters.Add("DRBSINTERVALL", OracleType.NVarChar).Value = dwData["DRBSINTERVALL"].ToString(); 
          or1.Parameters.Add("DRBSNEUDAT", OracleType.NVarChar).Value = dwData["DRBSNEUDAT"].ToString(); 
          or1.Parameters.Add("DRBSNEUBEN", OracleType.NVarChar).Value = dwData["DRBSNEUBEN"].ToString(); 
          or1.Parameters.Add("DRBSAENDAT", OracleType.NVarChar).Value = dwData["DRBSAENDAT"].ToString(); 
          or1.Parameters.Add("DRBSAENBEN", OracleType.NVarChar).Value = dwData["DRBSAENBEN"].ToString(); 
          or1.Parameters.Add("DRBSAENDZL", OracleType.NVarChar).Value = dwData["DRBSAENDZL"].ToString(); 
          or1.Parameters.Add("DRBSSTOP", OracleType.NVarChar).Value = dwData["DRBSSTOP"].ToString(); 
          or1.Parameters.Add("DRBSFILLER", OracleType.NVarChar).Value = dwData["DRBSFILLER"].ToString(); 
                    #endregion
                    break; 
                default:
                    break;
            }


            Connect2Proxy(or1);
        }
    }
}
